CREATE TABLE [dbo].[usr_test]
(
[idtest] [int] NOT NULL,
[codigo] [varchar] (8) COLLATE Modern_Spanish_CI_AS NOT NULL,
[nombre] [varchar] (255) COLLATE Modern_Spanish_CI_AS NOT NULL,
[apellido] [varchar] (255) COLLATE Modern_Spanish_CI_AS NOT NULL,
[edad] [int] NULL,
[disponible] [bit] NULL,
[instrumento] [int] NULL,
[estilo] [int] NULL,
[fecha] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usr_test] ADD CONSTRAINT [PK_usr_test] PRIMARY KEY CLUSTERED  ([idtest], [codigo]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usr_test] ADD CONSTRAINT [FK_usr_test_usr_estilo] FOREIGN KEY ([estilo]) REFERENCES [dbo].[usr_estilo] ([idestilo])
GO
ALTER TABLE [dbo].[usr_test] ADD CONSTRAINT [FK_usr_test_usr_instrumento] FOREIGN KEY ([instrumento]) REFERENCES [dbo].[usr_instrumento] ([idinst])
GO
